<?php

$sql = "
CREATE TABLE IF NOT EXISTS " . tablename('tim_submit_article') . " (
`aid` int(10) unsigned  AUTO_INCREMENT,
`sid` int(10),
`uniacid` int(11) NOT NULL,
`name` varchar(20) NOT NULL,
`tel` varchar(20) NOT NULL,
`title` varchar(100),
`content` text,
`adate` date,
 PRIMARY KEY (`aid`),
 INDEX(`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;";
pdo_query($sql);

$sql = "
CREATE TABLE IF NOT EXISTS " . tablename('tim_submit_set') . " (
`sid` int(10) unsigned  AUTO_INCREMENT,
`uniacid` int(11) NOT NULL,
`today` date,
`article_num` int(11) NOT NULL,
`cent` float,
`info` text,
`share_title` varchar(100),
`share_icon` varchar(200),
`share_content` varchar(200),
 PRIMARY KEY (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;";
pdo_query($sql);

$sql = "
CREATE TABLE IF NOT EXISTS " . tablename('tim_submit_user') . " (
`uid` int(10) unsigned  AUTO_INCREMENT,
`uniacid` int(11) NOT NULL,
`name` varchar(20),
`tel` int(11) NOT NULL,
`total_cent` float,
 PRIMARY KEY (`uid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;";
pdo_query($sql);
